Profiling Report

Dataset statistics

Number of variables	37
Number of observations	97152
Missing cells	110593
Missing cells (%)	3.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	28.2 MiB
Average record size in memory	304.0 B

Variable types

Text	9
Numeric	11
Categorical	9
DateTime	6
Boolean	1
Unsupported	1

Alerts

`Estimated Cost` is highly overall correlated with `Revised Cost`	High correlation
`Existing Construction Type` is highly overall correlated with `Existing Construction Type Description` and 2 other fields	High correlation
`Existing Construction Type Description` is highly overall correlated with `Existing Construction Type` and 2 other fields	High correlation
`Existing Units` is highly overall correlated with `Proposed Units`	High correlation
`Neighborhoods - Analysis Boundaries` is highly overall correlated with `Zipcode`	High correlation
`Number of Existing Stories` is highly overall correlated with `Number of Proposed Stories`	High correlation
`Number of Proposed Stories` is highly overall correlated with `Number of Existing Stories`	High correlation
`Permit Type` is highly overall correlated with `Permit Type Definition`	High correlation
`Permit Type Definition` is highly overall correlated with `Permit Type`	High correlation
`Proposed Construction Type` is highly overall correlated with `Existing Construction Type` and 2 other fields	High correlation
`Proposed Construction Type Description` is highly overall correlated with `Existing Construction Type` and 2 other fields	High correlation
`Proposed Units` is highly overall correlated with `Existing Units`	High correlation
`Revised Cost` is highly overall correlated with `Estimated Cost`	High correlation
`Zipcode` is highly overall correlated with `Neighborhoods - Analysis Boundaries`	High correlation
`Permit Type Definition` is highly imbalanced (85.2%)	Imbalance
`Street Suffix` is highly imbalanced (68.3%)	Imbalance
`Current Status` is highly imbalanced (99.5%)	Imbalance
`Plansets` is highly imbalanced (57.3%)	Imbalance
`Unit` has 82372 (84.8%) missing values	Missing
`Number of Existing Stories` has 1892 (1.9%) missing values	Missing
`Number of Proposed Stories` has 1654 (1.7%) missing values	Missing
`Existing Units` has 6971 (7.2%) missing values	Missing
`Proposed Units` has 6562 (6.8%) missing values	Missing
`Existing Construction Type` has 2226 (2.3%) missing values	Missing
`Existing Construction Type Description` has 2226 (2.3%) missing values	Missing
`Proposed Construction Type` has 1811 (1.9%) missing values	Missing
`Proposed Construction Type Description` has 1811 (1.9%) missing values	Missing
`Estimated Cost` is highly skewed (γ1 = 77.30022601)	Skewed
`Revised Cost` is highly skewed (γ1 = 75.01904853)	Skewed
`Supervisor District` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Unit` has 10489 (10.8%) zeros	Zeros
`Existing Units` has 18058 (18.6%) zeros	Zeros
`Proposed Units` has 17174 (17.7%) zeros	Zeros

Reproduction

Analysis started	2024-08-30 11:39:35.106127
Analysis finished	2024-08-30 11:40:17.840938
Duration	42.73 seconds
Software version	ydata-profiling vv4.9.0
Download configuration	config.json

Permit Number
Text

Distinct	88898
Distinct (%)	91.5%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Length

Max length	12
Median length	12
Mean length	11.999897
Min length	7

Characters and Unicode

Total characters	1165814
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	81979 ?
Unique (%)	84.4%

Sample

1st row	201305318356
2nd row	201410279983
3rd row	201307161925
4th row	201404113025
5th row	201702109134

Value	Count	Frequency (%)
201602179758	66	0.1%
201602179775	30	< 0.1%
201708165004	9	< 0.1%
201702239990	9	< 0.1%
201707061162	8	< 0.1%
201602179774	8	< 0.1%
201702099112	8	< 0.1%
201604285989	8	< 0.1%
201711284975	7	< 0.1%
201705267761	7	< 0.1%
Other values (88888)	96992	99.8%

Most occurring characters

Value	Count	Frequency (%)
0	257569	22.1%
1	216089	18.5%
2	191378	16.4%
3	83406	7.2%
5	78787	6.8%
4	78016	6.7%
6	75701	6.5%
7	70465	6.0%
8	57731	5.0%
9	56670	4.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1165812	> 99.9%
Uppercase Letter	2	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	257569	22.1%
1	216089	18.5%
2	191378	16.4%
3	83406	7.2%
5	78787	6.8%
4	78016	6.7%
6	75701	6.5%
7	70465	6.0%
8	57731	5.0%
9	56670	4.9%

Uppercase Letter

Value	Count	Frequency (%)
M	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1165812	> 99.9%
Latin	2	< 0.1%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	257569	22.1%
1	216089	18.5%
2	191378	16.4%
3	83406	7.2%
5	78787	6.8%
4	78016	6.7%
6	75701	6.5%
7	70465	6.0%
8	57731	5.0%
9	56670	4.9%

Latin

Value	Count	Frequency (%)
M	2	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1165814	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	257569	22.1%
1	216089	18.5%
2	191378	16.4%
3	83406	7.2%
5	78787	6.8%
4	78016	6.7%
6	75701	6.5%
7	70465	6.0%
8	57731	5.0%
9	56670	4.9%

Permit Type
Real number (ℝ)

HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.6743351

Minimum	1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	8
median	8
Q3	8
95-th percentile	8
Maximum	8
Range	7
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.220117
Coefficient of variation (CV)	0.15898667
Kurtosis	10.773969
Mean	7.6743351
Median Absolute Deviation (MAD)	0
Skewness	-3.5459275
Sum	745577
Variance	1.4886855
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
8	90502	93.2%
3	5013	5.2%
4	976	1.0%
2	305	0.3%
6	170	0.2%
7	103	0.1%
5	46	< 0.1%
1	37	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	37	< 0.1%
2	305	0.3%
3	5013	5.2%
4	976	1.0%
5	46	< 0.1%
6	170	0.2%
7	103	0.1%
8	90502	93.2%

Value	Count	Frequency (%)
8	90502	93.2%
7	103	0.1%
6	170	0.2%
5	46	< 0.1%
4	976	1.0%
3	5013	5.2%
2	305	0.3%
1	37	< 0.1%

Permit Type Definition
Categorical

HIGH CORRELATION IMBALANCE

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

otc alterations permit	90502
additions alterations or repairs	5013
sign - erect	976
new construction wood frame	305
demolitions	170
Other values (3)	186

Length

Max length	35
Median length	22
Mean length	22.413733
Min length	11

Characters and Unicode

Total characters	2177539
Distinct characters	23
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	otc alterations permit
2nd row	otc alterations permit
3rd row	otc alterations permit
4th row	otc alterations permit
5th row	otc alterations permit

Common Values

Value	Count	Frequency (%)
otc alterations permit	90502	93.2%
additions alterations or repairs	5013	5.2%
sign - erect	976	1.0%
new construction wood frame	305	0.3%
demolitions	170	0.2%
wall or painted sign	103	0.1%
grade or quarry or fill or excavate	46	< 0.1%
new construction	37	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
alterations	95515	32.2%
otc	90502	30.5%
permit	90502	30.5%
or	5254	1.8%
additions	5013	1.7%
repairs	5013	1.7%
sign	1079	0.4%
	976	0.3%
erect	976	0.3%
new	342	0.1%
Other values (10)	1512	0.5%

Most occurring characters

Value	Count	Frequency (%)
t	379026	17.4%
r	203058	9.3%
i	202966	9.3%
a	201751	9.3%
	199532	9.2%
o	197918	9.1%
e	194040	8.9%
s	107132	4.9%
n	102906	4.7%
l	95983	4.4%
Other values (13)	293227	13.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1977031	90.8%
Space Separator	199532	9.2%
Dash Punctuation	976	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	379026	19.2%
r	203058	10.3%
i	202966	10.3%
a	201751	10.2%
o	197918	10.0%
e	194040	9.8%
s	107132	5.4%
n	102906	5.2%
l	95983	4.9%
p	95618	4.8%
Other values (11)	196633	9.9%

Space Separator

Value	Count	Frequency (%)
	199532	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	976	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1977031	90.8%
Common	200508	9.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	379026	19.2%
r	203058	10.3%
i	202966	10.3%
a	201751	10.2%
o	197918	10.0%
e	194040	9.8%
s	107132	5.4%
n	102906	5.2%
l	95983	4.9%
p	95618	4.8%
Other values (11)	196633	9.9%

Common

Value	Count	Frequency (%)
	199532	99.5%
-	976	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2177539	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	379026	17.4%
r	203058	9.3%
i	202966	9.3%
a	201751	9.3%
	199532	9.2%
o	197918	9.1%
e	194040	8.9%
s	107132	4.9%
n	102906	4.7%
l	95983	4.4%
Other values (13)	293227	13.5%

Permit Creation Date
Date

Distinct	1289
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Minimum	2012-03-28 00:00:00
Maximum	2018-02-22 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Block
Text

Distinct	4716
Distinct (%)	4.9%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Length

Max length	5
Median length	4
Mean length	4.0394433
Min length	4

Characters and Unicode

Total characters	392440
Distinct characters	19
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	176 ?
Unique (%)	0.2%

Sample

1st row	1810
2nd row	0661
3rd row	3565
4th row	3740
5th row	0195

Value	Count	Frequency (%)
3708	790	0.8%
3735	481	0.5%
0289	413	0.4%
3717	399	0.4%
3709	382	0.4%
0259	375	0.4%
3721	372	0.4%
7331	372	0.4%
3706	349	0.4%
3707	326	0.3%
Other values (4706)	92893	95.6%

Most occurring characters

Value	Count	Frequency (%)
0	59621	15.2%
3	48339	12.3%
1	46772	11.9%
2	43137	11.0%
5	37954	9.7%
7	37630	9.6%
6	37207	9.5%
4	28623	7.3%
8	25273	6.4%
9	24053	6.1%
Other values (9)	3831	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	388609	99.0%
Uppercase Letter	3831	1.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	59621	15.3%
3	48339	12.4%
1	46772	12.0%
2	43137	11.1%
5	37954	9.8%
7	37630	9.7%
6	37207	9.6%
4	28623	7.4%
8	25273	6.5%
9	24053	6.2%

Uppercase Letter

Value	Count	Frequency (%)
A	2670	69.7%
B	492	12.8%
C	448	11.7%
D	69	1.8%
Z	61	1.6%
F	46	1.2%
E	36	0.9%
T	7	0.2%
G	2	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	388609	99.0%
Latin	3831	1.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	59621	15.3%
3	48339	12.4%
1	46772	12.0%
2	43137	11.1%
5	37954	9.8%
7	37630	9.7%
6	37207	9.6%
4	28623	7.4%
8	25273	6.5%
9	24053	6.2%

Latin

Value	Count	Frequency (%)
A	2670	69.7%
B	492	12.8%
C	448	11.7%
D	69	1.8%
Z	61	1.6%
F	46	1.2%
E	36	0.9%
T	7	0.2%
G	2	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	392440	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	59621	15.2%
3	48339	12.3%
1	46772	11.9%
2	43137	11.0%
5	37954	9.7%
7	37630	9.6%
6	37207	9.5%
4	28623	7.3%
8	25273	6.4%
9	24053	6.1%
Other values (9)	3831	1.0%

Lot
Text

Distinct	917
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Length

Max length	4
Median length	3
Mean length	3.0806468
Min length	3

Characters and Unicode

Total characters	299291
Distinct characters	36
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	207 ?
Unique (%)	0.2%

Sample

1st row	017A
2nd row	005
3rd row	076
4th row	029
5th row	001

Value	Count	Frequency (%)
001	4780	4.9%
007	2516	2.6%
008	2441	2.5%
006	2379	2.4%
002	2322	2.4%
003	2293	2.4%
005	2244	2.3%
009	2121	2.2%
021	2111	2.2%
004	2089	2.2%
Other values (907)	71856	74.0%

Most occurring characters

Value	Count	Frequency (%)
0	129587	43.3%
1	38712	12.9%
2	29546	9.9%
3	20919	7.0%
4	16236	5.4%
5	13299	4.4%
6	12441	4.2%
7	11042	3.7%
8	10099	3.4%
9	9581	3.2%
Other values (26)	7829	2.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	291462	97.4%
Uppercase Letter	7829	2.6%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	3786	48.4%
B	1394	17.8%
C	707	9.0%
D	466	6.0%
E	307	3.9%
F	232	3.0%
G	191	2.4%
I	106	1.4%
J	105	1.3%
H	104	1.3%
Other values (16)	431	5.5%

Decimal Number

Value	Count	Frequency (%)
0	129587	44.5%
1	38712	13.3%
2	29546	10.1%
3	20919	7.2%
4	16236	5.6%
5	13299	4.6%
6	12441	4.3%
7	11042	3.8%
8	10099	3.5%
9	9581	3.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	291462	97.4%
Latin	7829	2.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	3786	48.4%
B	1394	17.8%
C	707	9.0%
D	466	6.0%
E	307	3.9%
F	232	3.0%
G	191	2.4%
I	106	1.4%
J	105	1.3%
H	104	1.3%
Other values (16)	431	5.5%

Common

Value	Count	Frequency (%)
0	129587	44.5%
1	38712	13.3%
2	29546	10.1%
3	20919	7.2%
4	16236	5.6%
5	13299	4.6%
6	12441	4.3%
7	11042	3.8%
8	10099	3.5%
9	9581	3.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	299291	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	129587	43.3%
1	38712	12.9%
2	29546	9.9%
3	20919	7.0%
4	16236	5.4%
5	13299	4.4%
6	12441	4.2%
7	11042	3.7%
8	10099	3.4%
9	9581	3.2%
Other values (26)	7829	2.6%

Street Number
Real number (ℝ)

Distinct	4702
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1073.8915

Minimum	1
Maximum	8400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1
5-th percentile	29
Q1	219
median	650
Q3	1619
95-th percentile	3395
Maximum	8400
Range	8399
Interquartile range (IQR)	1400

Descriptive statistics

Standard deviation	1121.1989
Coefficient of variation (CV)	1.0440524
Kurtosis	2.5992423
Mean	1073.8915
Median Absolute Deviation (MAD)	539
Skewness	1.5247697
Sum	1.043307 × 10⁸
Variance	1257087.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1391	1.4%
101	689	0.7%
100	656	0.7%
50	655	0.7%
201	629	0.6%
555	597	0.6%
2	457	0.5%
55	417	0.4%
600	379	0.4%
150	371	0.4%
Other values (4692)	90911	93.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1391	1.4%
2	457	0.5%
3	173	0.2%
4	154	0.2%
5	89	0.1%
6	63	0.1%
7	65	0.1%
8	139	0.1%
9	63	0.1%
10	148	0.2%

Value	Count	Frequency (%)
8400	3	< 0.1%
8331	1	< 0.1%
8325	3	< 0.1%
8320	1	< 0.1%
8300	1	< 0.1%
8245	1	< 0.1%
8228	1	< 0.1%
8222	2	< 0.1%
8219	1	< 0.1%
8200	1	< 0.1%

Street Name
Text

Distinct	1578
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Length

Max length	25
Median length	22
Mean length	6.5469059
Min length	3

Characters and Unicode

Total characters	636045
Distinct characters	65
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	116 ?
Unique (%)	0.1%

Sample

1st row	43rD
2nd row	bUsH
3rd row	16tH
4th row	fOlSoM
5th row	mOnTgOmErY

Value	Count	Frequency (%)
market	3107	3.0%
california	2620	2.5%
mission	2074	2.0%
montgomery	1767	1.7%
20th	959	0.9%
03rd	929	0.9%
geary	909	0.9%
pine	831	0.8%
post	781	0.7%
folsom	762	0.7%
Other values (1571)	89455	85.9%

Most occurring characters

Value	Count	Frequency (%)
A	41831	6.6%
O	31090	4.9%
e	28234	4.4%
r	27733	4.4%
n	27600	4.3%
E	26220	4.1%
t	25542	4.0%
s	24001	3.8%
R	21729	3.4%
T	21451	3.4%
Other values (55)	360614	56.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	316394	49.7%
Uppercase Letter	277533	43.6%
Decimal Number	34974	5.5%
Space Separator	7050	1.1%
Other Punctuation	94	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	41831	15.1%
O	31090	11.2%
E	26220	9.4%
R	21729	7.8%
T	21451	7.7%
N	20280	7.3%
H	18459	6.7%
I	18354	6.6%
L	11588	4.2%
S	10995	4.0%
Other values (16)	55536	20.0%

Lowercase Letter

Value	Count	Frequency (%)
e	28234	8.9%
r	27733	8.8%
n	27600	8.7%
t	25542	8.1%
s	24001	7.6%
l	20024	6.3%
a	19865	6.3%
o	16970	5.4%
m	15914	5.0%
c	15876	5.0%
Other values (16)	94635	29.9%

Decimal Number

Value	Count	Frequency (%)
2	7294	20.9%
1	5819	16.6%
0	5521	15.8%
3	3937	11.3%
4	3739	10.7%
5	1869	5.3%
6	1796	5.1%
7	1739	5.0%
8	1732	5.0%
9	1528	4.4%

Other Punctuation

Value	Count	Frequency (%)
.	59	62.8%
'	35	37.2%

Space Separator

Value	Count	Frequency (%)
	7050	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	593927	93.4%
Common	42118	6.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	41831	7.0%
O	31090	5.2%
e	28234	4.8%
r	27733	4.7%
n	27600	4.6%
E	26220	4.4%
t	25542	4.3%
s	24001	4.0%
R	21729	3.7%
T	21451	3.6%
Other values (42)	318496	53.6%

Common

Value	Count	Frequency (%)
2	7294	17.3%
	7050	16.7%
1	5819	13.8%
0	5521	13.1%
3	3937	9.3%
4	3739	8.9%
5	1869	4.4%
6	1796	4.3%
7	1739	4.1%
8	1732	4.1%
Other values (3)	1622	3.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	636045	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	41831	6.6%
O	31090	4.9%
e	28234	4.4%
r	27733	4.4%
n	27600	4.3%
E	26220	4.1%
t	25542	4.0%
s	24001	3.8%
R	21729	3.4%
T	21451	3.4%
Other values (55)	360614	56.7%

Street Suffix
Categorical

IMBALANCE

Distinct	19
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

St	67798
Av	21803
Wy	1917
Dr	1842
Bl	1749
Other values (14)	2043

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	194304
Distinct characters	23
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	Av
2nd row	St
3rd row	St
4th row	St
5th row	St

Common Values

Value	Count	Frequency (%)
St	67798	69.8%
Av	21803	22.4%
Wy	1917	2.0%
Dr	1842	1.9%
Bl	1749	1.8%
Tr	743	0.8%
Ct	417	0.4%
Pl	240	0.2%
Ln	183	0.2%
Pz	116	0.1%
Other values (9)	344	0.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
st	67798	69.8%
av	21803	22.4%
wy	1917	2.0%
dr	1842	1.9%
bl	1749	1.8%
tr	743	0.8%
ct	417	0.4%
pl	240	0.2%
ln	183	0.2%
pz	116	0.1%
Other values (9)	344	0.4%

Most occurring characters

Value	Count	Frequency (%)
t	68215	35.1%
S	67800	34.9%
A	21839	11.2%
v	21803	11.2%
r	2638	1.4%
y	2027	1.0%
l	2025	1.0%
W	1917	1.0%
D	1842	0.9%
B	1749	0.9%
Other values (13)	2449	1.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	97152	50.0%
Uppercase Letter	97152	50.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	67800	69.8%
A	21839	22.5%
W	1917	2.0%
D	1842	1.9%
B	1749	1.8%
T	743	0.8%
C	470	0.5%
P	416	0.4%
L	183	0.2%
H	110	0.1%
Other values (2)	83	0.1%

Lowercase Letter

Value	Count	Frequency (%)
t	68215	70.2%
v	21803	22.4%
r	2638	2.7%
y	2027	2.1%
l	2025	2.1%
n	183	0.2%
z	116	0.1%
d	78	0.1%
k	60	0.1%
w	5	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	194304	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	68215	35.1%
S	67800	34.9%
A	21839	11.2%
v	21803	11.2%
r	2638	1.4%
y	2027	1.0%
l	2025	1.0%
W	1917	1.0%
D	1842	0.9%
B	1749	0.9%
Other values (13)	2449	1.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	194304	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	68215	35.1%
S	67800	34.9%
A	21839	11.2%
v	21803	11.2%
r	2638	1.4%
y	2027	1.0%
l	2025	1.0%
W	1917	1.0%
D	1842	0.9%
B	1749	0.9%
Other values (13)	2449	1.3%

Unit
Real number (ℝ)

MISSING ZEROS

Distinct	529
Distinct (%)	3.6%
Missing	82372
Missing (%)	84.8%
Infinite	0
Infinite (%)	0.0%
Mean	83.109675

Minimum	0
Maximum	6003
Zeros	10489
Zeros (%)	10.8%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	504
Maximum	6003
Range	6003
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	312.38325
Coefficient of variation (CV)	3.7586869
Kurtosis	80.146784
Mean	83.109675
Median Absolute Deviation (MAD)	0
Skewness	7.3730844
Sum	1228361
Variance	97583.293
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10489	10.8%
1	572	0.6%
2	311	0.3%
3	260	0.3%
101	151	0.2%
4	147	0.2%
5	110	0.1%
6	97	0.1%
201	94	0.1%
301	62	0.1%
Other values (519)	2487	2.6%
(Missing)	82372	84.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10489	10.8%
1	572	0.6%
2	311	0.3%
3	260	0.3%
4	147	0.2%
5	110	0.1%
6	97	0.1%
7	52	0.1%
8	57	0.1%
9	42	< 0.1%

Value	Count	Frequency (%)
6003	1	< 0.1%
5903	1	< 0.1%
5604	1	< 0.1%
5206	1	< 0.1%
5204	1	< 0.1%
5106	1	< 0.1%
4410	1	< 0.1%
4310	1	< 0.1%
4210	1	< 0.1%
4113	1	< 0.1%

Description
Text

Distinct	80515
Distinct (%)	82.9%
Missing	7
Missing (%)	< 0.1%
Memory size	1.5 MiB

Length

Max length	300
Median length	230
Mean length	121.29319
Min length	6

Characters and Unicode

Total characters	11783027
Distinct characters	70
Distinct categories	13 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	73753 ?
Unique (%)	75.9%

Sample

1st row	remodel kitchen: replace countertop, cabinets, sink, stove, hardwood floor & lighting.
2nd row	two kitchens & two bathrooms remodel. replace kitchen cabinets, countertops & appliances in same location. replace tub & faucet & vanity & tile in same location in both units.
3rd row	to comply with physical inspection report #cc-7260 item #1 -all storage items are being removed.
4th row	existing office and storage facility. new partitions, restroom upgrade. electrical on a separate permit
5th row	basement & 1/f- as built drawing for fire/smoke damper on hvac duct (existing) under pa#201612074341. n/a ordinance #155-13

Value	Count	Frequency (%)
to	55208	3.0%
	54501	2.9%
and	43163	2.3%
new	37595	2.0%
of	31582	1.7%
replace	23834	1.3%
in	23158	1.2%
with	21404	1.1%
for	21082	1.1%
floor	20021	1.1%
Other values (73055)	1537591	82.3%

Most occurring characters

Value	Count	Frequency (%)
	1796856	15.2%
e	969781	8.2%
o	772426	6.6%
r	736360	6.2%
n	694521	5.9%
t	677808	5.8%
i	668124	5.7%
a	662645	5.6%
l	477741	4.1%
s	455122	3.9%
Other values (60)	3871643	32.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8714474	74.0%
Space Separator	1796856	15.2%
Decimal Number	691927	5.9%
Other Punctuation	447125	3.8%
Dash Punctuation	56363	0.5%
Close Punctuation	37775	0.3%
Open Punctuation	36558	0.3%
Math Symbol	1767	< 0.1%
Currency Symbol	141	< 0.1%
Connector Punctuation	28	< 0.1%
Other values (3)	13	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	969781	11.1%
o	772426	8.9%
r	736360	8.4%
n	694521	8.0%
t	677808	7.8%
i	668124	7.7%
a	662645	7.6%
l	477741	5.5%
s	455122	5.2%
d	365726	4.2%
Other values (17)	2234220	25.6%

Other Punctuation

Value	Count	Frequency (%)
.	181358	40.6%
,	116009	25.9%
&	35639	8.0%
#	34376	7.7%
/	32350	7.2%
:	17075	3.8%
;	9298	2.1%
"	7394	1.7%
'	5363	1.2%
@	3530	0.8%
Other values (5)	4733	1.1%

Decimal Number

Value	Count	Frequency (%)
1	144313	20.9%
0	122539	17.7%
2	119967	17.3%
3	64534	9.3%
5	57302	8.3%
4	51237	7.4%
6	39148	5.7%
7	33864	4.9%
8	31139	4.5%
9	27884	4.0%

Math Symbol

Value	Count	Frequency (%)
<	632	35.8%
+	532	30.1%
=	427	24.2%
>	143	8.1%
~	33	1.9%

Dash Punctuation

Value	Count	Frequency (%)
-	56362	> 99.9%
–	1	< 0.1%

Close Punctuation

Value	Count	Frequency (%)
)	37768	> 99.9%
]	7	< 0.1%

Open Punctuation

Value	Count	Frequency (%)
(	36540	> 99.9%
[	18	< 0.1%

Modifier Symbol

Value	Count	Frequency (%)
^	6	60.0%
`	4	40.0%

Space Separator

Value	Count	Frequency (%)
	1796856	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	141	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	28	100.0%

Other Number

Value	Count	Frequency (%)
½	2	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8714474	74.0%
Common	3068553	26.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
	1796856	58.6%
.	181358	5.9%
1	144313	4.7%
0	122539	4.0%
2	119967	3.9%
,	116009	3.8%
3	64534	2.1%
5	57302	1.9%
-	56362	1.8%
4	51237	1.7%
Other values (33)	358076	11.7%

Latin

Value	Count	Frequency (%)
e	969781	11.1%
o	772426	8.9%
r	736360	8.4%
n	694521	8.0%
t	677808	7.8%
i	668124	7.7%
a	662645	7.6%
l	477741	5.5%
s	455122	5.2%
d	365726	4.2%
Other values (17)	2234220	25.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11782970	> 99.9%
None	55	< 0.1%
Punctuation	2	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1796856	15.2%
e	969781	8.2%
o	772426	6.6%
r	736360	6.2%
n	694521	5.9%
t	677808	5.8%
i	668124	5.7%
a	662645	5.6%
l	477741	4.1%
s	455122	3.9%
Other values (56)	3871586	32.9%

None

Value	Count	Frequency (%)
ç	53	96.4%
½	2	3.6%

Punctuation

Value	Count	Frequency (%)
–	1	50.0%
’	1	50.0%

Current Status
Categorical

IMBALANCE

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

complete	97040
issued	52
reinstated	36
expired	7
cancelled	5
Other values (4)	12

Length

Max length	10
Median length	8
Mean length	7.9995986
Min length	6

Characters and Unicode

Total characters	777177
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	complete
2nd row	complete
3rd row	complete
4th row	complete
5th row	complete

Common Values

Value	Count	Frequency (%)
complete	97040	99.9%
issued	52	0.1%
reinstated	36	< 0.1%
expired	7	< 0.1%
cancelled	5	< 0.1%
revoked	4	< 0.1%
approved	4	< 0.1%
suspend	3	< 0.1%
incomplete	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
complete	97040	99.9%
issued	52	0.1%
reinstated	36	< 0.1%
expired	7	< 0.1%
cancelled	5	< 0.1%
revoked	4	< 0.1%
approved	4	< 0.1%
suspend	3	< 0.1%
incomplete	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	194245	25.0%
t	97113	12.5%
p	97059	12.5%
c	97051	12.5%
l	97051	12.5%
o	97049	12.5%
m	97041	12.5%
s	146	< 0.1%
d	111	< 0.1%
i	96	< 0.1%
Other values (7)	215	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	777177	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	194245	25.0%
t	97113	12.5%
p	97059	12.5%
c	97051	12.5%
l	97051	12.5%
o	97049	12.5%
m	97041	12.5%
s	146	< 0.1%
d	111	< 0.1%
i	96	< 0.1%
Other values (7)	215	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	777177	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	194245	25.0%
t	97113	12.5%
p	97059	12.5%
c	97051	12.5%
l	97051	12.5%
o	97049	12.5%
m	97041	12.5%
s	146	< 0.1%
d	111	< 0.1%
i	96	< 0.1%
Other values (7)	215	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	777177	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	194245	25.0%
t	97113	12.5%
p	97059	12.5%
c	97051	12.5%
l	97051	12.5%
o	97049	12.5%
m	97041	12.5%
s	146	< 0.1%
d	111	< 0.1%
i	96	< 0.1%
Other values (7)	215	< 0.1%

Current Status Date
Date

Distinct	1301
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Minimum	2013-01-04 00:00:00
Maximum	2018-02-23 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Filed Date
Date

Distinct	1287
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Minimum	2013-01-02 00:00:00
Maximum	2018-02-22 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Issued Date
Date

Distinct	1288
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Minimum	2013-01-02 00:00:00
Maximum	2018-02-22 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Completed Date
Date

Distinct	1300
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Minimum	2013-01-04 00:00:00
Maximum	2018-02-23 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

First Construction Document Date
Date

Distinct	1287
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Minimum	2013-01-02 00:00:00
Maximum	2018-02-22 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Number of Existing Stories
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	62
Distinct (%)	0.1%
Missing	1892
Missing (%)	1.9%
Infinite	0
Infinite (%)	0.0%
Mean	5.9407254

Minimum	0
Maximum	78
Zeros	233
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	27
Maximum	78
Range	78
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	8.8678258
Coefficient of variation (CV)	1.4927177
Kurtosis	9.5685779
Mean	5.9407254
Median Absolute Deviation (MAD)	1
Skewness	3.0823604
Sum	565913.5
Variance	78.638334
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	32407	33.4%
3	27642	28.5%
4	9257	9.5%
1	5028	5.2%
5	2276	2.3%
6	2251	2.3%
7	1450	1.5%
8	1038	1.1%
9	753	0.8%
10	731	0.8%
Other values (52)	12427	12.8%
(Missing)	1892	1.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	233	0.2%
1	5028	5.2%
1.5	1	< 0.1%
2	32407	33.4%
2.5	2	< 0.1%
3	27642	28.5%
4	9257	9.5%
5	2276	2.3%
6	2251	2.3%
7	1450	1.5%

Value	Count	Frequency (%)
78	1	< 0.1%
63	10	< 0.1%
62	1	< 0.1%
61	2	< 0.1%
60	11	< 0.1%
58	66	0.1%
55	2	< 0.1%
53	6	< 0.1%
52	276	0.3%
50	21	< 0.1%

Number of Proposed Stories
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	63
Distinct (%)	0.1%
Missing	1654
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%
Mean	5.973324

Minimum	0
Maximum	78
Zeros	82
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	27
Maximum	78
Range	78
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	8.8716531
Coefficient of variation (CV)	1.4852121
Kurtosis	9.6211189
Mean	5.973324
Median Absolute Deviation (MAD)	1
Skewness	3.0891829
Sum	570440.5
Variance	78.706229
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	31835	32.8%
3	28030	28.9%
4	9881	10.2%
1	4722	4.9%
5	2431	2.5%
6	2329	2.4%
7	1433	1.5%
8	1039	1.1%
9	781	0.8%
10	718	0.7%
Other values (53)	12299	12.7%
(Missing)	1654	1.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	82	0.1%
1	4722	4.9%
1.5	1	< 0.1%
2	31835	32.8%
2.5	2	< 0.1%
3	28030	28.9%
4	9881	10.2%
5	2431	2.5%
6	2329	2.4%
7	1433	1.5%

Value	Count	Frequency (%)
78	1	< 0.1%
63	13	< 0.1%
62	3	< 0.1%
61	2	< 0.1%
60	11	< 0.1%
58	66	0.1%
55	4	< 0.1%
54	1	< 0.1%
53	6	< 0.1%
52	275	0.3%

Fire Only Permit
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	853.9 KiB

False	84354
True	12798

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	84354	86.8%
True	12798	13.2%

Permit Expiration Date
Text

Distinct	1992
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	971520
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	133 ?
Unique (%)	0.1%

Sample

1st row	05/29/2014
2nd row	10/22/2015
3rd row	07/11/2014
4th row	04/09/2017
5th row	02/05/2018

Value	Count	Frequency (%)
02/24/2018	162	0.2%
02/28/2018	158	0.2%
06/17/2017	143	0.1%
02/03/2018	140	0.1%
04/30/2018	136	0.1%
07/26/2015	135	0.1%
03/24/2017	129	0.1%
05/20/2017	129	0.1%
10/09/2016	128	0.1%
02/23/2018	126	0.1%
Other values (1982)	95766	98.6%

Most occurring characters

Value	Count	Frequency (%)
0	221084	22.8%
/	194276	20.0%
1	174893	18.0%
2	152707	15.7%
6	39114	4.0%
7	38840	4.0%
5	37865	3.9%
4	36368	3.7%
8	33139	3.4%
3	24637	2.5%
Other values (7)	18597	1.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	777104	80.0%
Other Punctuation	194276	20.0%
Lowercase Letter	140	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	221084	28.4%
1	174893	22.5%
2	152707	19.7%
6	39114	5.0%
7	38840	5.0%
5	37865	4.9%
4	36368	4.7%
8	33139	4.3%
3	24637	3.2%
9	18457	2.4%

Lowercase Letter

Value	Count	Frequency (%)
i	42	30.0%
n	28	20.0%
d	28	20.0%
e	14	10.0%
f	14	10.0%
a	14	10.0%

Other Punctuation

Value	Count	Frequency (%)
/	194276	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	971380	> 99.9%
Latin	140	< 0.1%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	221084	22.8%
/	194276	20.0%
1	174893	18.0%
2	152707	15.7%
6	39114	4.0%
7	38840	4.0%
5	37865	3.9%
4	36368	3.7%
8	33139	3.4%
3	24637	2.5%

Latin

Value	Count	Frequency (%)
i	42	30.0%
n	28	20.0%
d	28	20.0%
e	14	10.0%
f	14	10.0%
a	14	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	971520	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	221084	22.8%
/	194276	20.0%
1	174893	18.0%
2	152707	15.7%
6	39114	4.0%
7	38840	4.0%
5	37865	3.9%
4	36368	3.7%
8	33139	3.4%
3	24637	2.5%
Other values (7)	18597	1.9%

Estimated Cost
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	7924
Distinct (%)	8.2%
Missing	90
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	7.0276836 × 10^-18

Minimum	-0.075252115
Maximum	133.08421
Zeros	0
Zeros (%)	0.0%
Negative	85490
Negative (%)	88.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	-0.075252115
5-th percentile	-0.075252115
Q1	-0.072205731
median	-0.065095134
Q3	-0.044779141
95-th percentile	0.1279068
Maximum	133.08421
Range	133.15946
Interquartile range (IQR)	0.02742659

Descriptive statistics

Standard deviation	1.0000052
Coefficient of variation (CV)	1.4229513 × 10¹⁷
Kurtosis	7902.587
Mean	7.0276836 × 10^-18
Median Absolute Deviation (MAD)	0.0091421967
Skewness	77.300226
Sum	4.8151066 × 10^-13
Variance	1.0000103
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.07525211457	10531	10.8%
-0.06509513403	3963	4.1%
-0.0701741322	3851	4.0%
-0.05493713768	3393	3.5%
-0.06001613586	3010	3.1%
-0.04477914134	2353	2.4%
-0.04985813951	2196	2.3%
-0.07220573147	2161	2.2%
-0.0671267333	2000	2.1%
-0.07322153111	1967	2.0%
Other values (7914)	61637	63.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.07525211457	10531	10.8%
-0.07525109877	1	< 0.1%
-0.07524906718	2	< 0.1%
-0.07524805138	1	< 0.1%
-0.07524297238	4	< 0.1%
-0.07523281438	3	< 0.1%
-0.07522773538	7	< 0.1%
-0.07522265639	1	< 0.1%
-0.07521757739	1	< 0.1%
-0.07521249839	1	< 0.1%

Value	Count	Frequency (%)
133.0842103	1	< 0.1%
106.5837085	3	< 0.1%
62.90432421	1	< 0.1%
57.22397265	1	< 0.1%
55.79372677	1	< 0.1%
50.71472859	1	< 0.1%
40.22964477	1	< 0.1%
39.54093262	2	< 0.1%
35.47773408	2	< 0.1%
35.402057	1	< 0.1%

Revised Cost
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	8765
Distinct (%)	9.0%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	-1.0678144 × 10^-17

Minimum	-0.084131372
Maximum	130.56436
Zeros	0
Zeros (%)	0.0%
Negative	85035
Negative (%)	87.5%
Memory size	1.5 MiB

Quantile statistics

Minimum	-0.084131372
5-th percentile	-0.084130375
Q1	-0.080344122
median	-0.072171634
Q3	-0.049248803
95-th percentile	0.16502984
Maximum	130.56436
Range	130.64849
Interquartile range (IQR)	0.031095319

Descriptive statistics

Standard deviation	1.0000051
Coefficient of variation (CV)	-9.3649713 × 10¹⁶
Kurtosis	7484.1131
Mean	-1.0678144 × 10^-17
Median Absolute Deviation (MAD)	0.0106641
Skewness	75.019049
Sum	-9.7516439 × 10^-13
Variance	1.0000103
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.08413037543	9969	10.3%
-0.07914814791	3503	3.6%
-0.07416492375	3417	3.5%
-0.06419847543	3078	3.2%
-0.06918169959	2672	2.8%
-0.05423202712	2175	2.2%
-0.05921525127	2049	2.1%
-0.08114143758	1969	2.0%
-0.08213808241	1946	2.0%
-0.07615821342	1716	1.8%
Other values (8755)	64657	66.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.08413137207	2	< 0.1%
-0.08413037543	9969	10.3%
-0.0841301761	1	< 0.1%
-0.08412937878	2	< 0.1%
-0.08412638885	2	< 0.1%
-0.08412140562	4	< 0.1%
-0.08411741904	1	< 0.1%
-0.08411143918	1	< 0.1%
-0.08410645595	4	< 0.1%
-0.0840964895	1	< 0.1%

Value	Count	Frequency (%)
130.5643613	1	< 0.1%
104.563576	3	< 0.1%
73.06407389	1	< 0.1%
61.70784821	1	< 0.1%
49.74811022	1	< 0.1%
44.76488606	1	< 0.1%
41.92444829	1	< 0.1%
40.40556157	1	< 0.1%
38.78501707	2	< 0.1%
34.79843774	2	< 0.1%

Existing Use
Text

Distinct	93
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Length

Max length	20
Median length	19
Mean length	13.092649
Min length	4

Characters and Unicode

Total characters	1271977
Distinct characters	40
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	< 0.1%

Sample

1st row	1 family dwelling
2nd row	2 family dwelling
3rd row	apartments
4th row	office
5th row	retail sales

Value	Count	Frequency (%)
family	42347	21.7%
dwelling	42347	21.7%
1	28903	14.8%
apartments	24388	12.5%
office	16117	8.2%
2	13444	6.9%
sales	3752	1.9%
retail	3703	1.9%
food/beverage	2674	1.4%
hndlng	2674	1.4%
Other values (144)	15015	7.7%

Most occurring characters

Value	Count	Frequency (%)
l	144132	11.3%
i	113575	8.9%
a	108318	8.5%
e	107957	8.5%
	98212	7.7%
f	79468	6.2%
n	79247	6.2%
m	69234	5.4%
t	63083	5.0%
d	52037	4.1%
Other values (30)	356714	28.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1124432	88.4%
Space Separator	98212	7.7%
Decimal Number	42438	3.3%
Other Punctuation	5451	0.4%
Uppercase Letter	1085	0.1%
Dash Punctuation	347	< 0.1%
Open Punctuation	6	< 0.1%
Close Punctuation	6	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
l	144132	12.8%
i	113575	10.1%
a	108318	9.6%
e	107957	9.6%
f	79468	7.1%
n	79247	7.0%
m	69234	6.2%
t	63083	5.6%
d	52037	4.6%
g	49431	4.4%
Other values (15)	257950	22.9%

Decimal Number

Value	Count	Frequency (%)
1	28939	68.2%
2	13480	31.8%
6	11	< 0.1%
7	7	< 0.1%
3	1	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
/	4617	84.7%
,	588	10.8%
&	160	2.9%
.	84	1.5%
'	2	< 0.1%

Space Separator

Value	Count	Frequency (%)
	98212	100.0%

Uppercase Letter

Value	Count	Frequency (%)
N	1085	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	347	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	6	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	6	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1125517	88.5%
Common	146460	11.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
l	144132	12.8%
i	113575	10.1%
a	108318	9.6%
e	107957	9.6%
f	79468	7.1%
n	79247	7.0%
m	69234	6.2%
t	63083	5.6%
d	52037	4.6%
g	49431	4.4%
Other values (16)	259035	23.0%

Common

Value	Count	Frequency (%)
	98212	67.1%
1	28939	19.8%
2	13480	9.2%
/	4617	3.2%
,	588	0.4%
-	347	0.2%
&	160	0.1%
.	84	0.1%
6	11	< 0.1%
7	7	< 0.1%
Other values (4)	15	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1271977	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
l	144132	11.3%
i	113575	8.9%
a	108318	8.5%
e	107957	8.5%
	98212	7.7%
f	79468	6.2%
n	79247	6.2%
m	69234	5.4%
t	63083	5.0%
d	52037	4.1%
Other values (30)	356714	28.0%

Existing Units
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	312
Distinct (%)	0.3%
Missing	6971
Missing (%)	7.2%
Infinite	0
Infinite (%)	0.0%
Mean	15.60685

Minimum	0
Maximum	1907
Zeros	18058
Zeros (%)	18.6%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	4
95-th percentile	64
Maximum	1907
Range	1907
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	74.145567
Coefficient of variation (CV)	4.750835
Kurtosis	236.27048
Mean	15.60685
Median Absolute Deviation (MAD)	1
Skewness	12.780574
Sum	1407441.3
Variance	5497.5651
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	29185	30.0%
0	18058	18.6%
2	13874	14.3%
3	5725	5.9%
4	3403	3.5%
6	2984	3.1%
12	1426	1.5%
5	1199	1.2%
8	918	0.9%
7	665	0.7%
Other values (302)	12744	13.1%
(Missing)	6971	7.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	18058	18.6%
0.3	1	< 0.1%
1	29185	30.0%
2	13874	14.3%
3	5725	5.9%
4	3403	3.5%
5	1199	1.2%
6	2984	3.1%
7	665	0.7%
8	918	0.9%

Value	Count	Frequency (%)
1907	26	< 0.1%
1732	3	< 0.1%
1500	35	< 0.1%
1499	1	< 0.1%
1186	26	< 0.1%
1010	2	< 0.1%
1005	10	< 0.1%
1004	2	< 0.1%
840	35	< 0.1%
754	4	< 0.1%

Proposed Use
Text

Distinct	93
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Length

Max length	20
Median length	19
Mean length	13.135931
Min length	4

Characters and Unicode

Total characters	1276182
Distinct characters	40
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	< 0.1%

Sample

1st row	1 family dwelling
2nd row	2 family dwelling
3rd row	apartments
4th row	office
5th row	retail sales

Value	Count	Frequency (%)
family	42650	21.8%
dwelling	42650	21.8%
1	28782	14.7%
apartments	25310	13.0%
office	15839	8.1%
2	13868	7.1%
food/beverage	2907	1.5%
hndlng	2907	1.5%
sales	2907	1.5%
retail	2842	1.5%
Other values (144)	14538	7.4%

Most occurring characters

Value	Count	Frequency (%)
l	143067	11.2%
i	113637	8.9%
e	108374	8.5%
a	107525	8.4%
	98048	7.7%
n	80232	6.3%
f	79662	6.2%
m	70654	5.5%
t	62426	4.9%
d	53762	4.2%
Other values (30)	358795	28.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1127745	88.4%
Space Separator	98048	7.7%
Decimal Number	42788	3.4%
Other Punctuation	5670	0.4%
Uppercase Letter	1468	0.1%
Dash Punctuation	443	< 0.1%
Open Punctuation	10	< 0.1%
Close Punctuation	10	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
l	143067	12.7%
i	113637	10.1%
e	108374	9.6%
a	107525	9.5%
n	80232	7.1%
f	79662	7.1%
m	70654	6.3%
t	62426	5.5%
d	53762	4.8%
g	50052	4.4%
Other values (15)	258354	22.9%

Decimal Number

Value	Count	Frequency (%)
1	28839	67.4%
2	13925	32.5%
7	13	< 0.1%
6	10	< 0.1%
3	1	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
/	4844	85.4%
,	499	8.8%
&	229	4.0%
.	84	1.5%
'	14	0.2%

Space Separator

Value	Count	Frequency (%)
	98048	100.0%

Uppercase Letter

Value	Count	Frequency (%)
N	1468	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	443	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	10	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	10	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1129213	88.5%
Common	146969	11.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
l	143067	12.7%
i	113637	10.1%
e	108374	9.6%
a	107525	9.5%
n	80232	7.1%
f	79662	7.1%
m	70654	6.3%
t	62426	5.5%
d	53762	4.8%
g	50052	4.4%
Other values (16)	259822	23.0%

Common

Value	Count	Frequency (%)
	98048	66.7%
1	28839	19.6%
2	13925	9.5%
/	4844	3.3%
,	499	0.3%
-	443	0.3%
&	229	0.2%
.	84	0.1%
'	14	< 0.1%
7	13	< 0.1%
Other values (4)	31	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1276182	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
l	143067	11.2%
i	113637	8.9%
e	108374	8.5%
a	107525	8.4%
	98048	7.7%
n	80232	6.3%
f	79662	6.2%
m	70654	5.5%
t	62426	4.9%
d	53762	4.2%
Other values (30)	358795	28.1%

Proposed Units
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	332
Distinct (%)	0.4%
Missing	6562
Missing (%)	6.8%
Infinite	0
Infinite (%)	0.0%
Mean	16.310023

Minimum	0
Maximum	1911
Zeros	17174
Zeros (%)	17.7%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	4
95-th percentile	70
Maximum	1911
Range	1911
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	74.840036
Coefficient of variation (CV)	4.5885916
Kurtosis	221.89618
Mean	16.310023
Median Absolute Deviation (MAD)	1
Skewness	12.266222
Sum	1477525
Variance	5601.0309
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	29075	29.9%
0	17174	17.7%
2	14304	14.7%
3	6010	6.2%
4	3450	3.6%
6	3009	3.1%
12	1444	1.5%
5	1208	1.2%
8	919	0.9%
7	699	0.7%
Other values (322)	13298	13.7%
(Missing)	6562	6.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	17174	17.7%
1	29075	29.9%
2	14304	14.7%
3	6010	6.2%
4	3450	3.6%
5	1208	1.2%
6	3009	3.1%
7	699	0.7%
8	919	0.9%
9	677	0.7%

Value	Count	Frequency (%)
1911	1	< 0.1%
1907	25	< 0.1%
1732	3	< 0.1%
1500	32	< 0.1%
1499	1	< 0.1%
1186	26	< 0.1%
1014	4	< 0.1%
1010	2	< 0.1%
1005	8	< 0.1%
840	33	< 0.1%

Plansets
Categorical

IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

2.0	54489
0.0	42643
3.0	17
4.0	2
9000.0	1

Length

Max length	6
Median length	3
Mean length	3.0000309
Min length	3

Characters and Unicode

Total characters	291459
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	2.0
2nd row	0.0
3rd row	0.0
4th row	2.0
5th row	2.0

Common Values

Value	Count	Frequency (%)
2.0	54489	56.1%
0.0	42643	43.9%
3.0	17	< 0.1%
4.0	2	< 0.1%
9000.0	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2.0	54489	56.1%
0.0	42643	43.9%
3.0	17	< 0.1%
4.0	2	< 0.1%
9000.0	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	139798	48.0%
.	97152	33.3%
2	54489	18.7%
3	17	< 0.1%
4	2	< 0.1%
9	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	194307	66.7%
Other Punctuation	97152	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	139798	71.9%
2	54489	28.0%
3	17	< 0.1%
4	2	< 0.1%
9	1	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
.	97152	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	291459	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	139798	48.0%
.	97152	33.3%
2	54489	18.7%
3	17	< 0.1%
4	2	< 0.1%
9	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	291459	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	139798	48.0%
.	97152	33.3%
2	54489	18.7%
3	17	< 0.1%
4	2	< 0.1%
9	1	< 0.1%

Existing Construction Type
Categorical

HIGH CORRELATION MISSING

Distinct	5
Distinct (%)	< 0.1%
Missing	2226
Missing (%)	2.3%
Memory size	1.5 MiB

5.0	68610
1.0	18109
3.0	5610
2.0	2360
4.0	237

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	284778
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5.0
2nd row	5.0
3rd row	5.0
4th row	3.0
5th row	3.0

Common Values

Value	Count	Frequency (%)
5.0	68610	70.6%
1.0	18109	18.6%
3.0	5610	5.8%
2.0	2360	2.4%
4.0	237	0.2%
(Missing)	2226	2.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5.0	68610	72.3%
1.0	18109	19.1%
3.0	5610	5.9%
2.0	2360	2.5%
4.0	237	0.2%

Most occurring characters

Value	Count	Frequency (%)
.	94926	33.3%
0	94926	33.3%
5	68610	24.1%
1	18109	6.4%
3	5610	2.0%
2	2360	0.8%
4	237	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	189852	66.7%
Other Punctuation	94926	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	94926	50.0%
5	68610	36.1%
1	18109	9.5%
3	5610	3.0%
2	2360	1.2%
4	237	0.1%

Other Punctuation

Value	Count	Frequency (%)
.	94926	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	284778	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	94926	33.3%
0	94926	33.3%
5	68610	24.1%
1	18109	6.4%
3	5610	2.0%
2	2360	0.8%
4	237	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	284778	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	94926	33.3%
0	94926	33.3%
5	68610	24.1%
1	18109	6.4%
3	5610	2.0%
2	2360	0.8%
4	237	0.1%

Existing Construction Type Description
Categorical

HIGH CORRELATION MISSING

Distinct	5
Distinct (%)	< 0.1%
Missing	2226
Missing (%)	2.3%
Memory size	1.5 MiB

wood frame (5)	68610
constr type 1	18109
constr type 3	5610
constr type 2	2360
constr type 4	237

Length

Max length	14
Median length	14
Mean length	13.722774
Min length	13

Characters and Unicode

Total characters	1302648
Distinct characters	22
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	wood frame (5)
2nd row	wood frame (5)
3rd row	wood frame (5)
4th row	constr type 3
5th row	constr type 3

Common Values

Value	Count	Frequency (%)
wood frame (5)	68610	70.6%
constr type 1	18109	18.6%
constr type 3	5610	5.8%
constr type 2	2360	2.4%
constr type 4	237	0.2%
(Missing)	2226	2.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
wood	68610	24.1%
frame	68610	24.1%
5	68610	24.1%
constr	26316	9.2%
type	26316	9.2%
1	18109	6.4%
3	5610	2.0%
2	2360	0.8%
4	237	0.1%

Most occurring characters

Value	Count	Frequency (%)
	189852	14.6%
o	163536	12.6%
r	94926	7.3%
e	94926	7.3%
d	68610	5.3%
w	68610	5.3%
f	68610	5.3%
a	68610	5.3%
m	68610	5.3%
(	68610	5.3%
Other values (12)	347748	26.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	880650	67.6%
Space Separator	189852	14.6%
Decimal Number	94926	7.3%
Open Punctuation	68610	5.3%
Close Punctuation	68610	5.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	163536	18.6%
r	94926	10.8%
e	94926	10.8%
d	68610	7.8%
w	68610	7.8%
f	68610	7.8%
a	68610	7.8%
m	68610	7.8%
t	52632	6.0%
c	26316	3.0%
Other values (4)	105264	12.0%

Decimal Number

Value	Count	Frequency (%)
5	68610	72.3%
1	18109	19.1%
3	5610	5.9%
2	2360	2.5%
4	237	0.2%

Space Separator

Value	Count	Frequency (%)
	189852	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	68610	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	68610	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	880650	67.6%
Common	421998	32.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	163536	18.6%
r	94926	10.8%
e	94926	10.8%
d	68610	7.8%
w	68610	7.8%
f	68610	7.8%
a	68610	7.8%
m	68610	7.8%
t	52632	6.0%
c	26316	3.0%
Other values (4)	105264	12.0%

Common

Value	Count	Frequency (%)
	189852	45.0%
(	68610	16.3%
5	68610	16.3%
)	68610	16.3%
1	18109	4.3%
3	5610	1.3%
2	2360	0.6%
4	237	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1302648	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	189852	14.6%
o	163536	12.6%
r	94926	7.3%
e	94926	7.3%
d	68610	5.3%
w	68610	5.3%
f	68610	5.3%
a	68610	5.3%
m	68610	5.3%
(	68610	5.3%
Other values (12)	347748	26.7%

Proposed Construction Type
Categorical

HIGH CORRELATION MISSING

Distinct	5
Distinct (%)	< 0.1%
Missing	1811
Missing (%)	1.9%
Memory size	1.5 MiB

5.0	69200
1.0	18066
3.0	5579
2.0	2254
4.0	242

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	286023
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5.0
2nd row	5.0
3rd row	5.0
4th row	3.0
5th row	3.0

Common Values

Value	Count	Frequency (%)
5.0	69200	71.2%
1.0	18066	18.6%
3.0	5579	5.7%
2.0	2254	2.3%
4.0	242	0.2%
(Missing)	1811	1.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5.0	69200	72.6%
1.0	18066	18.9%
3.0	5579	5.9%
2.0	2254	2.4%
4.0	242	0.3%

Most occurring characters

Value	Count	Frequency (%)
.	95341	33.3%
0	95341	33.3%
5	69200	24.2%
1	18066	6.3%
3	5579	2.0%
2	2254	0.8%
4	242	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	190682	66.7%
Other Punctuation	95341	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	95341	50.0%
5	69200	36.3%
1	18066	9.5%
3	5579	2.9%
2	2254	1.2%
4	242	0.1%

Other Punctuation

Value	Count	Frequency (%)
.	95341	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	286023	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	95341	33.3%
0	95341	33.3%
5	69200	24.2%
1	18066	6.3%
3	5579	2.0%
2	2254	0.8%
4	242	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	286023	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	95341	33.3%
0	95341	33.3%
5	69200	24.2%
1	18066	6.3%
3	5579	2.0%
2	2254	0.8%
4	242	0.1%

Proposed Construction Type Description
Categorical

HIGH CORRELATION MISSING

Distinct	5
Distinct (%)	< 0.1%
Missing	1811
Missing (%)	1.9%
Memory size	1.5 MiB

wood frame (5)	69200
constr type 1	18066
constr type 3	5579
constr type 2	2254
constr type 4	242

Length

Max length	14
Median length	14
Mean length	13.725816
Min length	13

Characters and Unicode

Total characters	1308633
Distinct characters	22
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	wood frame (5)
2nd row	wood frame (5)
3rd row	wood frame (5)
4th row	constr type 3
5th row	constr type 3

Common Values

Value	Count	Frequency (%)
wood frame (5)	69200	71.2%
constr type 1	18066	18.6%
constr type 3	5579	5.7%
constr type 2	2254	2.3%
constr type 4	242	0.2%
(Missing)	1811	1.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
wood	69200	24.2%
frame	69200	24.2%
5	69200	24.2%
constr	26141	9.1%
type	26141	9.1%
1	18066	6.3%
3	5579	2.0%
2	2254	0.8%
4	242	0.1%

Most occurring characters

Value	Count	Frequency (%)
	190682	14.6%
o	164541	12.6%
r	95341	7.3%
e	95341	7.3%
d	69200	5.3%
w	69200	5.3%
f	69200	5.3%
a	69200	5.3%
m	69200	5.3%
(	69200	5.3%
Other values (12)	347528	26.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	884210	67.6%
Space Separator	190682	14.6%
Decimal Number	95341	7.3%
Open Punctuation	69200	5.3%
Close Punctuation	69200	5.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	164541	18.6%
r	95341	10.8%
e	95341	10.8%
d	69200	7.8%
w	69200	7.8%
f	69200	7.8%
a	69200	7.8%
m	69200	7.8%
t	52282	5.9%
c	26141	3.0%
Other values (4)	104564	11.8%

Decimal Number

Value	Count	Frequency (%)
5	69200	72.6%
1	18066	18.9%
3	5579	5.9%
2	2254	2.4%
4	242	0.3%

Space Separator

Value	Count	Frequency (%)
	190682	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	69200	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	69200	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	884210	67.6%
Common	424423	32.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	164541	18.6%
r	95341	10.8%
e	95341	10.8%
d	69200	7.8%
w	69200	7.8%
f	69200	7.8%
a	69200	7.8%
m	69200	7.8%
t	52282	5.9%
c	26141	3.0%
Other values (4)	104564	11.8%

Common

Value	Count	Frequency (%)
	190682	44.9%
(	69200	16.3%
5	69200	16.3%
)	69200	16.3%
1	18066	4.3%
3	5579	1.3%
2	2254	0.5%
4	242	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1308633	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	190682	14.6%
o	164541	12.6%
r	95341	7.3%
e	95341	7.3%
d	69200	5.3%
w	69200	5.3%
f	69200	5.3%
a	69200	5.3%
m	69200	5.3%
(	69200	5.3%
Other values (12)	347528	26.6%

Supervisor District
Unsupported

REJECTED UNSUPPORTED

Missing	745
Missing (%)	0.8%
Memory size	1.5 MiB

Neighborhoods - Analysis Boundaries
Categorical

HIGH CORRELATION

Distinct	41
Distinct (%)	< 0.1%
Missing	746
Missing (%)	0.8%
Memory size	1.5 MiB

Financial District/South Beach	13101
Mission	6440
Sunset/Parkside	5692
West of Twin Peaks	4963
Castro/Upper Market	4015
Other values (36)	62195

Length

Max length	30
Median length	18
Mean length	15.325768
Min length	6

Characters and Unicode

Total characters	1477496
Distinct characters	46
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Sunset/Parkside
2nd row	Pacific Heights
3rd row	Castro/Upper Market
4th row	Financial District/South Beach
5th row	Chinatown

Common Values

Value	Count	Frequency (%)
Financial District/South Beach	13101	13.5%
Mission	6440	6.6%
Sunset/Parkside	5692	5.9%
West of Twin Peaks	4963	5.1%
Castro/Upper Market	4015	4.1%
Outer Richmond	3890	4.0%
Marina	3689	3.8%
South of Market	3665	3.8%
Noe Valley	3644	3.8%
Pacific Heights	3502	3.6%
Other values (31)	43805	45.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
beach	14909	7.6%
financial	13101	6.6%
district/south	13101	6.6%
mission	8740	4.4%
of	8628	4.4%
heights	8240	4.2%
market	7680	3.9%
hill	6768	3.4%
valley	6471	3.3%
richmond	5912	3.0%
Other values (46)	103465	52.5%

Most occurring characters

Value	Count	Frequency (%)
i	142454	9.6%
e	117518	8.0%
a	105040	7.1%
t	102051	6.9%
n	101490	6.9%
	100609	6.8%
s	87954	6.0%
o	74432	5.0%
r	74020	5.0%
c	59334	4.0%
Other values (36)	512594	34.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1130576	76.5%
Uppercase Letter	219067	14.8%
Space Separator	100609	6.8%
Other Punctuation	27244	1.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	142454	12.6%
e	117518	10.4%
a	105040	9.3%
t	102051	9.0%
n	101490	9.0%
s	87954	7.8%
o	74432	6.6%
r	74020	6.5%
c	59334	5.2%
h	55371	4.9%
Other values (13)	210912	18.7%

Uppercase Letter

Value	Count	Frequency (%)
S	27532	12.6%
P	23596	10.8%
M	23198	10.6%
H	22571	10.3%
B	21570	9.8%
F	14811	6.8%
D	13101	6.0%
R	8167	3.7%
T	8071	3.7%
N	7937	3.6%
Other values (11)	48513	22.1%

Space Separator

Value	Count	Frequency (%)
	100609	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	27244	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1349643	91.3%
Common	127853	8.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	142454	10.6%
e	117518	8.7%
a	105040	7.8%
t	102051	7.6%
n	101490	7.5%
s	87954	6.5%
o	74432	5.5%
r	74020	5.5%
c	59334	4.4%
h	55371	4.1%
Other values (34)	429979	31.9%

Common

Value	Count	Frequency (%)
	100609	78.7%
/	27244	21.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1477496	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	142454	9.6%
e	117518	8.0%
a	105040	7.1%
t	102051	6.9%
n	101490	6.9%
	100609	6.8%
s	87954	6.0%
o	74432	5.0%
r	74020	5.0%
c	59334	4.0%
Other values (36)	512594	34.7%

Zipcode
Real number (ℝ)

HIGH CORRELATION

Distinct	27
Distinct (%)	< 0.1%
Missing	744
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%
Mean	94115.436

Minimum	94102
Maximum	94158
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	94102
5-th percentile	94103
Q1	94109
median	94114
Q3	94122
95-th percentile	94133
Maximum	94158
Range	56
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	9.354154
Coefficient of variation (CV)	9.9390221 × 10^-5
Kurtosis	1.2429194
Mean	94115.436
Median Absolute Deviation (MAD)	7
Skewness	0.86801113
Sum	9.073481 × 10⁹
Variance	87.500196
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
94110	8259	8.5%
94114	6172	6.4%
94117	5347	5.5%
94105	5265	5.4%
94103	5084	5.2%
94109	4864	5.0%
94122	4603	4.7%
94115	4516	4.6%
94118	4441	4.6%
94123	4266	4.4%
Other values (17)	43591	44.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
94102	3235	3.3%
94103	5084	5.2%
94104	2755	2.8%
94105	5265	5.4%
94107	3921	4.0%
94108	2476	2.5%
94109	4864	5.0%
94110	8259	8.5%
94111	3213	3.3%
94112	4101	4.2%

Value	Count	Frequency (%)
94158	549	0.6%
94134	1497	1.5%
94133	3151	3.2%
94132	1948	2.0%
94131	3948	4.1%
94130	31	< 0.1%
94129	7	< 0.1%
94127	2892	3.0%
94124	2338	2.4%
94123	4266	4.4%

Location
Text

Distinct	37119
Distinct (%)	38.5%
Missing	735
Missing (%)	0.8%
Memory size	1.5 MiB

Length

Max length	41
Median length	40
Mean length	40.042337
Min length	35

Characters and Unicode

Total characters	3860762
Distinct characters	16
Distinct categories	6 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	20266 ?
Unique (%)	21.0%

Sample

1st row	(37.759041020475465, -122.50286985467523)
2nd row	(37.78762264983362, -122.43099126735969)
3rd row	(37.76416871595274, -122.43039745629406)
4th row	(37.78992343288329, -122.3915399961996)
5th row	(37.79621627942539, -122.40375479881872)

Value	Count	Frequency (%)
37.79226164705184	375	0.2%
122.4034859571375	375	0.2%
37.79294896659241	228	0.1%
122.39809861435491	228	0.1%
37.78377017210105	180	0.1%
122.43195970140347	180	0.1%
122.47676641508518	177	0.1%
37.728556952954136	177	0.1%
37.793357219595194	171	0.1%
122.39421470312315	171	0.1%
Other values (74220)	190572	98.8%

Most occurring characters

Value	Count	Frequency (%)
2	439465	11.4%
7	436673	11.3%
3	361250	9.4%
1	343725	8.9%
4	339738	8.8%
5	262047	6.8%
9	256732	6.6%
8	256653	6.6%
6	254448	6.6%
0	235112	6.1%
Other values (6)	674919	17.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3185843	82.5%
Other Punctuation	289251	7.5%
Open Punctuation	96417	2.5%
Space Separator	96417	2.5%
Dash Punctuation	96417	2.5%
Close Punctuation	96417	2.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	439465	13.8%
7	436673	13.7%
3	361250	11.3%
1	343725	10.8%
4	339738	10.7%
5	262047	8.2%
9	256732	8.1%
8	256653	8.1%
6	254448	8.0%
0	235112	7.4%

Other Punctuation

Value	Count	Frequency (%)
.	192834	66.7%
,	96417	33.3%

Open Punctuation

Value	Count	Frequency (%)
(	96417	100.0%

Space Separator

Value	Count	Frequency (%)
	96417	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	96417	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	96417	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3860762	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	439465	11.4%
7	436673	11.3%
3	361250	9.4%
1	343725	8.9%
4	339738	8.8%
5	262047	6.8%
9	256732	6.6%
8	256653	6.6%
6	254448	6.6%
0	235112	6.1%
Other values (6)	674919	17.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3860762	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	439465	11.4%
7	436673	11.3%
3	361250	9.4%
1	343725	8.9%
4	339738	8.8%
5	262047	6.8%
9	256732	6.6%
8	256653	6.6%
6	254448	6.6%
0	235112	6.1%
Other values (6)	674919	17.5%

Record ID
Real number (ℝ)

Distinct	97148
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1574893 × 10¹²

Minimum	1.2935322 × 10¹⁰
Maximum	1.4981672 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1.2935322 × 10¹⁰
5-th percentile	1.3371992 × 10¹¹
Q1	1.3062539 × 10¹²
median	1.3585908 × 10¹²
Q3	1.4152727 × 10¹²
95-th percentile	1.4693428 × 10¹²
Maximum	1.4981672 × 10¹²
Range	1.4852319 × 10¹²
Interquartile range (IQR)	1.0901874 × 10¹¹

Descriptive statistics

Standard deviation	4.8075057 × 10¹¹
Coefficient of variation (CV)	0.4153391
Kurtosis	0.71685322
Mean	1.1574893 × 10¹²
Median Absolute Deviation (MAD)	5.4266169 × 10¹⁰
Skewness	-1.6260545
Sum	1.124524 × 10¹⁷
Variance	2.3112111 × 10²³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.344366188 × 10¹²	2	< 0.1%
1.414026241 × 10¹²	2	< 0.1%
1.350685167 × 10¹²	2	< 0.1%
1.301037451 × 10¹²	2	< 0.1%
1.339291367 × 10¹²	1	< 0.1%
1.365494153 × 10¹²	1	< 0.1%
1.471852133 × 10¹²	1	< 0.1%
1.336888489 × 10¹²	1	< 0.1%
1.406675165 × 10¹²	1	< 0.1%
1.404037288 × 10¹²	1	< 0.1%
Other values (97138)	97138	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.29353215 × 10¹⁰	1	< 0.1%
1.295722223 × 10¹⁰	1	< 0.1%
1.296226196 × 10¹⁰	1	< 0.1%
1.296629102 × 10¹⁰	1	< 0.1%
1.297668221 × 10¹⁰	1	< 0.1%
1.298230162 × 10¹⁰	1	< 0.1%
1.299548187 × 10¹⁰	1	< 0.1%
1.302453234 × 10¹⁰	1	< 0.1%
1.3025251 × 10¹⁰	1	< 0.1%
1.3025301 × 10¹⁰	1	< 0.1%

Value	Count	Frequency (%)
1.498167208 × 10¹²	1	< 0.1%
1.497918511 × 10¹²	1	< 0.1%
1.497908141 × 10¹²	1	< 0.1%
1.497865153 × 10¹²	1	< 0.1%
1.497759172 × 10¹²	1	< 0.1%
1.497639217 × 10¹²	1	< 0.1%
1.497595146 × 10¹²	1	< 0.1%
1.497593146 × 10¹²	1	< 0.1%
1.497577112 × 10¹²	1	< 0.1%
1.497564467 × 10¹²	1	< 0.1%

Auto

Heatmap
Table

	Current Status	Estimated Cost	Existing Construction Type	Existing Construction Type Description	Existing Units	Fire Only Permit	Neighborhoods - Analysis Boundaries	Number of Existing Stories	Number of Proposed Stories	Permit Type	Permit Type Definition	Plansets	Proposed Construction Type	Proposed Construction Type Description	Proposed Units	Record ID	Revised Cost	Street Number	Street Suffix	Unit	Zipcode
Current Status	1.000	0.000	0.000	0.000	0.000	0.004	0.018	0.000	0.000	0.011	0.011	0.000	0.000	0.000	0.000	0.013	0.000	0.000	0.000	0.000	0.002
Estimated Cost	0.000	1.000	0.007	0.007	-0.040	0.005	0.016	0.114	0.114	-0.145	0.235	0.033	0.013	0.013	-0.046	-0.031	0.958	-0.038	0.018	0.031	-0.042
Existing Construction Type	0.000	0.007	1.000	1.000	0.141	0.432	0.438	0.411	0.414	0.060	0.060	0.197	0.995	0.995	0.140	0.092	0.006	0.126	0.154	0.133	0.310
Existing Construction Type Description	0.000	0.007	1.000	1.000	0.141	0.432	0.438	0.411	0.414	0.060	0.060	0.197	0.995	0.995	0.140	0.092	0.006	0.126	0.154	0.133	0.310
Existing Units	0.000	-0.040	0.141	0.141	1.000	0.075	0.138	0.151	0.137	0.024	0.012	0.027	0.142	0.142	0.985	0.030	-0.036	0.180	0.072	0.466	0.062
Fire Only Permit	0.004	0.005	0.432	0.432	0.075	1.000	0.414	0.370	0.362	0.050	0.050	0.337	0.429	0.429	0.075	0.064	0.000	0.123	0.149	0.032	0.309
Neighborhoods - Analysis Boundaries	0.018	0.016	0.438	0.438	0.138	0.414	1.000	0.280	0.282	0.145	0.145	0.194	0.434	0.434	0.136	0.365	0.016	0.318	0.220	0.114	0.774
Number of Existing Stories	0.000	0.114	0.411	0.411	0.151	0.370	0.280	1.000	0.988	0.000	0.026	0.149	0.413	0.413	0.146	-0.120	0.117	-0.143	0.094	0.191	-0.426
Number of Proposed Stories	0.000	0.114	0.414	0.414	0.137	0.362	0.282	0.988	1.000	-0.028	0.029	0.149	0.413	0.413	0.157	-0.121	0.120	-0.141	0.095	0.189	-0.429
Permit Type	0.011	-0.145	0.060	0.060	0.024	0.050	0.145	0.000	-0.028	1.000	1.000	0.116	0.036	0.036	-0.032	0.066	-0.168	-0.017	0.100	0.050	0.004
Permit Type Definition	0.011	0.235	0.060	0.060	0.012	0.050	0.145	0.026	0.029	1.000	1.000	0.116	0.036	0.036	0.009	0.049	0.232	0.020	0.100	0.000	0.046
Plansets	0.000	0.033	0.197	0.197	0.027	0.337	0.194	0.149	0.149	0.116	0.116	1.000	0.195	0.195	0.029	0.057	0.034	0.042	0.083	0.028	0.148
Proposed Construction Type	0.000	0.013	0.995	0.995	0.142	0.429	0.434	0.413	0.413	0.036	0.036	0.195	1.000	1.000	0.140	0.091	0.015	0.125	0.155	0.133	0.312
Proposed Construction Type Description	0.000	0.013	0.995	0.995	0.142	0.429	0.434	0.413	0.413	0.036	0.036	0.195	1.000	1.000	0.140	0.091	0.015	0.125	0.155	0.133	0.312
Proposed Units	0.000	-0.046	0.140	0.140	0.985	0.075	0.136	0.146	0.157	-0.032	0.009	0.029	0.140	0.140	1.000	0.027	-0.040	0.179	0.076	0.464	0.049
Record ID	0.013	-0.031	0.092	0.092	0.030	0.064	0.365	-0.120	-0.121	0.066	0.049	0.057	0.091	0.091	0.027	1.000	-0.032	-0.016	0.105	-0.237	0.014
Revised Cost	0.000	0.958	0.006	0.006	-0.036	0.000	0.016	0.117	0.120	-0.168	0.232	0.034	0.015	0.015	-0.040	-0.032	1.000	-0.036	0.015	0.020	-0.047
Street Number	0.000	-0.038	0.126	0.126	0.180	0.123	0.318	-0.143	-0.141	-0.017	0.020	0.042	0.125	0.125	0.179	-0.016	-0.036	1.000	0.118	0.019	0.160
Street Suffix	0.000	0.018	0.154	0.154	0.072	0.149	0.220	0.094	0.095	0.100	0.100	0.083	0.155	0.155	0.076	0.105	0.015	0.118	1.000	0.080	0.254
Unit	0.000	0.031	0.133	0.133	0.466	0.032	0.114	0.191	0.189	0.050	0.000	0.028	0.133	0.133	0.464	-0.237	0.020	0.019	0.080	1.000	-0.022
Zipcode	0.002	-0.042	0.310	0.310	0.062	0.309	0.774	-0.426	-0.429	0.004	0.046	0.148	0.312	0.312	0.049	0.014	-0.047	0.160	0.254	-0.022	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Permit Number	Permit Type	Permit Type Definition	Permit Creation Date	Block	Lot	Street Number	Street Name	Street Suffix	Unit	Description	Current Status	Current Status Date	Filed Date	Issued Date	Completed Date	First Construction Document Date	Number of Existing Stories	Number of Proposed Stories	Fire Only Permit	Permit Expiration Date	Estimated Cost	Revised Cost	Existing Use	Existing Units	Proposed Use	Proposed Units	Plansets	Existing Construction Type	Existing Construction Type Description	Proposed Construction Type	Proposed Construction Type Description	Supervisor District	Neighborhoods - Analysis Boundaries	Zipcode	Location	Record ID
1	201305318356	8	otc alterations permit	05/31/2013	1810	017A	1483	43rD	Av	NaN	remodel kitchen: replace countertop, cabinets, sink, stove, hardwood floor & lighting.	complete	08/28/2013	05/31/2013	06/03/2013	08/28/2013	06/03/2013	2.0	2.0	N	05/29/2014	-0.063064	-0.072172	1 family dwelling	1.0	1 family dwelling	1.0	2.0	5.0	wood frame (5)	5.0	wood frame (5)	4.0	Sunset/Parkside	94122.0	(37.759041020475465, -122.50286985467523)	1306559115258
3	201410279983	8	otc alterations permit	10/27/2014	0661	005	2020	bUsH	St	NaN	two kitchens & two bathrooms remodel. replace kitchen cabinets, countertops & appliances in same location. replace tub & faucet & vanity & tile in same location in both units.	complete	12/31/2014	10/27/2014	10/27/2014	12/31/2014	10/27/2014	2.0	2.0	N	10/22/2015	-0.039700	-0.049249	2 family dwelling	2.0	2 family dwelling	2.0	0.0	5.0	wood frame (5)	5.0	wood frame (5)	5.0	Pacific Heights	94115.0	(37.78762264983362, -122.43099126735969)	136037778128
5	201307161925	8	otc alterations permit	07/16/2013	3565	076	3479	16tH	St	NaN	to comply with physical inspection report #cc-7260 item #1 -all storage items are being removed.	complete	10/08/2013	07/16/2013	07/16/2013	10/08/2013	07/16/2013	3.0	3.0	N	07/11/2014	-0.067635	-0.076657	apartments	3.0	apartments	3.0	0.0	5.0	wood frame (5)	5.0	wood frame (5)	8.0	Castro/Upper Market	94114.0	(37.76416871595274, -122.43039745629406)	1311167285194
8	201404113025	8	otc alterations permit	04/11/2014	3740	029	126	fOlSoM	St	NaN	existing office and storage facility. new partitions, restroom upgrade. electrical on a separate permit	complete	10/02/2014	04/11/2014	04/25/2014	10/02/2014	04/25/2014	1.0	1.0	N	04/09/2017	0.051722	0.040449	office	NaN	office	NaN	2.0	3.0	constr type 3	3.0	constr type 3	6.0	Financial District/South Beach	94105.0	(37.78992343288329, -122.3915399961996)	1338371165676
9	201702109134	8	otc alterations permit	02/10/2017	0195	001	735	mOnTgOmErY	St	NaN	basement & 1/f- as built drawing for fire/smoke damper on hvac duct (existing) under pa#201612074341. n/a ordinance #155-13	complete	03/09/2017	02/10/2017	02/10/2017	03/09/2017	02/10/2017	4.0	4.0	N	02/05/2018	-0.075252	-0.084130	retail sales	0.0	retail sales	0.0	2.0	3.0	constr type 3	3.0	constr type 3	3.0	Chinatown	94111.0	(37.79621627942539, -122.40375479881872)	145294162223
12	201301319171	8	otc alterations permit	01/31/2013	5683	009	319	gAtEs	St	NaN	to obtain final inspection for work approved under pa#200907092266 all work is complete.	complete	02/25/2013	01/31/2013	01/31/2013	02/25/2013	01/31/2013	2.0	2.0	N	01/26/2014	-0.075252	-0.084130	1 family dwelling	1.0	1 family dwelling	1.0	0.0	5.0	wood frame (5)	5.0	wood frame (5)	9.0	Bernal Heights	94110.0	(37.738645966485414, -122.41376867233384)	1294812186759
13	201703272374	8	otc alterations permit	03/27/2017	5254	016A	1586	hUdSoN	Av	NaN	reroofing - n/a maher	complete	03/31/2017	03/27/2017	03/27/2017	03/31/2017	03/27/2017	3.0	3.0	N	03/22/2018	-0.062302	-0.071424	2 family dwelling	2.0	2 family dwelling	2.0	0.0	5.0	wood frame (5)	5.0	wood frame (5)	10.0	Bayview Hunters Point	94124.0	(37.74009281621103, -122.38782062796065)	1457402178140
14	201306139496	8	otc alterations permit	06/13/2013	3708	058	575	mArKeT	St	NaN	relocate (4) sprinklers per t.i, 38th fl. t.i ref pa# 201305298105.	complete	07/01/2013	06/13/2013	06/17/2013	07/01/2013	06/17/2013	40.0	40.0	Y	06/12/2014	-0.073165	-0.082082	office	NaN	office	NaN	2.0	1.0	constr type 1	1.0	constr type 1	6.0	Financial District/South Beach	94105.0	(37.789550846009895, -122.40035964704002)	1307996164536
15	201507282656	8	otc alterations permit	07/28/2015	0274	016	995	pInE	St	NaN	unit 205: replace kitchen counter tops and cabinets. replace bathtub, vanity and tiles in bathroom.	complete	10/15/2015	07/28/2015	07/28/2015	10/15/2015	07/28/2015	5.0	5.0	N	07/22/2016	-0.056969	-0.066192	apartments	29.0	apartments	29.0	0.0	5.0	wood frame (5)	5.0	wood frame (5)	3.0	Nob Hill	94108.0	(37.79048343152098, -122.41201759718454)	1389955233429
16	201309177045	4	sign - erect	09/17/2013	1517	037	6333	gEaRy	Bl	NaN	erect electric sign	complete	11/19/2013	09/17/2013	09/17/2013	11/19/2013	09/17/2013	1.0	NaN	N	09/12/2014	-0.068650	-0.077653	retail sales	0.0	No definido	NaN	2.0	3.0	constr type 3	NaN	NaN	1.0	Outer Richmond	94121.0	(37.779635697353044, -122.48739021723274)	1317862102479

	Permit Number	Permit Type	Permit Type Definition	Permit Creation Date	Block	Lot	Street Number	Street Name	Street Suffix	Unit	Description	Current Status	Current Status Date	Filed Date	Issued Date	Completed Date	First Construction Document Date	Number of Existing Stories	Number of Proposed Stories	Fire Only Permit	Permit Expiration Date	Estimated Cost	Revised Cost	Existing Use	Existing Units	Proposed Use	Proposed Units	Plansets	Existing Construction Type	Existing Construction Type Description	Proposed Construction Type	Proposed Construction Type Description	Supervisor District	Neighborhoods - Analysis Boundaries	Zipcode	Location	Record ID
198887	201302260962	8	otc alterations permit	02/26/2013	0910	003	3741	bRoDeRiCk	St	NaN	reroofing	complete	03/25/2013	02/26/2013	02/26/2013	03/25/2013	02/26/2013	3.0	3.0	N	02/21/2014	-0.059405	-0.068582	1 family dwelling	1.0	1 family dwelling	1.0	0.0	5.0	wood frame (5)	5.0	wood frame (5)	2.0	Marina	94123.0	(37.80496756184145, -122.4458427365375)	129714583806
198892	201410209315	8	otc alterations permit	10/20/2014	1158	022	1884	mCaLlIsTeR	St	NaN	remove 7 (e) windows on 2/f & 3/f at rear of building to be replaced with 2 new raised panel glass windows & 2 (n) fixed windows.	complete	12/04/2014	10/20/2014	10/31/2014	12/04/2014	10/31/2014	3.0	3.0	N	10/26/2015	-0.070174	-0.064198	apartments	4.0	apartments	4.0	2.0	5.0	wood frame (5)	5.0	wood frame (5)	5.0	Lone Mountain/USF	94115.0	(37.777413174246156, -122.44320680410473)	1359485463242
198893	201411121217	8	otc alterations permit	11/12/2014	0328	001	760	mArKeT	St	NaN	7th fl: electrical, lighting, power & signal t.i. pa# 201409176549. n/a ordinance #155-13	complete	09/04/2015	11/12/2014	11/14/2014	09/04/2015	11/14/2014	11.0	11.0	N	10/29/2017	0.583396	0.562098	office	0.0	office	0.0	2.0	1.0	constr type 1	1.0	constr type 1	3.0	Financial District/South Beach	94108.0	(37.786382767276045, -122.40546332975441)	136200169778
198894	201403060109	8	otc alterations permit	03/06/2014	3534	077	254	cLiNtOn	Pk	0.0	install fiber cement siding materials on front elevation and entry way; fiberdemen6t window trim included. u-factor not more than .32	complete	12/16/2014	03/06/2014	03/06/2014	12/16/2014	03/06/2014	2.0	2.0	N	03/01/2015	-0.064587	-0.073667	2 family dwelling	2.0	2 family dwelling	2.0	0.0	5.0	wood frame (5)	5.0	wood frame (5)	8.0	Mission	94103.0	(37.76920156531753, -122.42572939292191)	1334652472658
198897	201703010402	8	otc alterations permit	03/01/2017	5413	038	1623	wAlLaCe	Av	NaN	abate nov 201651391 - repair fire & water damage, replacement of ceiling, walls and floor finishes down to rough framing. no layout & framing changes. remodel kitchen and bath on upper level, approx 800 sf of area in repair. work only on legal installations. replace 5 rear windows. other work under	complete	10/31/2017	03/01/2017	03/01/2017	10/31/2017	03/01/2017	2.0	2.0	N	02/24/2018	-0.004147	-0.014366	1 family dwelling	1.0	1 family dwelling	1.0	0.0	5.0	wood frame (5)	5.0	wood frame (5)	10.0	Bayview Hunters Point	94124.0	(37.72754415299655, -122.39176691964768)	1454702182099
198898	201606018815	8	otc alterations permit	06/01/2016	3561	086	295	cAsTrO	St	NaN	remodel #293 at 2/f, remodel (e) bathrooms, relocate kitchen, add washer & dryer, alter one bearing wall.	complete	10/13/2016	06/01/2016	06/06/2016	10/13/2016	06/06/2016	4.0	4.0	N	06/01/2017	-0.024463	0.010550	apartments	10.0	apartments	10.0	2.0	5.0	wood frame (5)	5.0	wood frame (5)	8.0	Castro/Upper Market	94114.0	(37.76430617710508, -122.43502013192992)	1425631158737
198900	201506027767	8	otc alterations permit	06/02/2015	7101A	007	736	hUrOn	Av	NaN	reroofing	complete	03/11/2016	06/02/2015	06/02/2015	03/11/2016	06/02/2015	2.0	2.0	N	05/27/2016	-0.069158	-0.078152	1 family dwelling	1.0	1 family dwelling	1.0	0.0	5.0	wood frame (5)	5.0	wood frame (5)	11.0	Outer Mission	94112.0	(37.71192805393076, -122.4500944316179)	1383549221502
198902	201609208175	8	otc alterations permit	09/20/2016	2130A	006G	78	cRaGmOnT	Av	NaN	replace (e) tub with walk in tub, 20 amp circuit, gfci outlet	complete	09/28/2016	09/20/2016	09/20/2016	09/28/2016	09/20/2016	2.0	2.0	N	09/15/2017	-0.057070	-0.066291	1 family dwelling	1.0	1 family dwelling	1.0	0.0	5.0	wood frame (5)	5.0	wood frame (5)	7.0	Inner Sunset	94116.0	(37.74973733662819, -122.4671301493082)	1438114126978
198903	201407161416	8	otc alterations permit	07/16/2014	2528	024	66	cReStLaKe	Dr	NaN	cut a door and a staircase for access to backyard.build deck next to staircase.	complete	01/23/2015	07/16/2014	10/28/2014	01/23/2015	10/28/2014	2.0	2.0	N	10/23/2015	-0.070682	-0.078152	1 family dwelling	1.0	1 family dwelling	1.0	2.0	5.0	wood frame (5)	5.0	wood frame (5)	4.0	Sunset/Parkside	94132.0	(37.73542953855242, -122.48149902038024)	1349089138746
198905	201604053958	3	additions alterations or repairs	04/05/2016	7295	021	3251	20tH	Av	NaN	ti for space 129,130, 132 partitions, mep, shelving, stonestown mall. ab -56 compliance 2014-0627-9771	complete	11/22/2016	04/05/2016	07/18/2016	11/22/2016	07/18/2016	2.0	2.0	N	07/03/2019	0.254882	0.840764	retail sales	0.0	retail sales	0.0	2.0	2.0	constr type 2	2.0	constr type 2	7.0	Lakeshore	94132.0	(37.728556952954136, -122.47676641508518)	1418495226171

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Decimal Number

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks